Select DISTINCT(yr) from (select year(issue_date) as yr, issue_date from paper_master,color_master,stamps where issue_date!='' and  color_master.color_code=stamps.color_code and color_master.color='Magenta'  and paper_master.paper_code=stamps.paper_code and paper_master.paper='Watermark All over multiple 'Lion Capital of Ashoka''  order by issue_date) t